﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'GetJuridicoByIdCliente')
	BEGIN
		DROP  Procedure  GetJuridicoByIdCliente
	END

GO

CREATE Procedure GetJuridicoByIdCliente

	(
		@idCliente int
	)


AS

BEGIN
	SET NOCOUNT ON
	
	SELECT
	[GiroNegocio],
	[IdCliente],
	[IdJuridico],
	[RazonSocial],
	[RUC]
	FROM [Juridico] 
	WHERE [IdCliente] = @idCliente

	SET NOCOUNT OFF
END

GO


GRANT EXEC ON GetJuridicoByIdCliente TO PUBLIC

GO


